For Magento 1.9 and older
|
1
|
UPDATE admin_user SET password = CONCAT(MD5(‘xxNewPassword’), ‘:xx’) WHERE username = ‘ADMINUSERNAME’;
|
For Magento 2:
|
1
|
UPDATE admin_user SET password = CONCAT(SHA2(‘xxxxxxxxNewPassword’, 256), ‘:xxxxxxxx:1’) WHERE username = ‘ADMINUSERNAME’;
|